DROP TABLE IF EXISTS sys_menu;
create table sys_menu
(
  menu_id     varchar(32)           not null,
  parent_id   varchar(32)           null,
  menu_name   varchar(50)           null,
  route_path  varchar(256)          null,
  icon        varchar(256)          null,
  component   varchar(256)          null,
  is_show    integer      default 1 null,
  keep_alive  integer     default 1 null,
  is_ext      integer     default 0 null,
  type        varchar(32)           not null,
  status      integer               NOT NULL DEFAULT 0,
  order_no    int                   NOT NULL DEFAULT 0,
  pinyin_code varchar(32) DEFAULT NULL,
  wubi_code   varchar(32) DEFAULT NULL,
  create_by   varchar(32) DEFAULT NULL,
  create_at   date        DEFAULT NULL,
  update_by   varchar(32) DEFAULT NULL,
  update_at   date        DEFAULT NULL,
  delete_flag char     DEFAULT 0,
  tenant_id   varchar(32) DEFAULT '0',
  primary key (menu_id)
);

BEGIN;
INSERT INTO sys_menu (menu_id, parent_id, menu_name, route_path, icon, component, is_show, keep_alive, is_ext, type,
                      status, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag,
                      tenant_id)
VALUES ('1904960886332121090', '0', '仪表板', '/analytics', 'ion:layers-outline', 'BasicLayout', 1, 1, 0, '0', '0', 1,
        'YBB', 'WGS', 'admin', '2025-03-27 02:17:22', 'admin', '2025-03-27 04:01:11', '0', '0');
INSERT INTO sys_menu (menu_id, parent_id, menu_name, route_path, icon, component, is_show, keep_alive, is_ext, type,
                      status, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag,
                      tenant_id)
VALUES ('1904963087666438146', '1904960886332121090', '分析', '/dashboard/analysis', 'ant-design:account-book-outlined',
        '/dashboard/analytics/index', 1, 1, 0, '1', '0', 1, 'FX', 'WS', 'admin', '2025-03-27 02:26:07', 'admin',
        '2025-03-27 04:01:38', '0', '0');
INSERT INTO sys_menu (menu_id, parent_id, menu_name, route_path, icon, component, is_show, keep_alive, is_ext, type,
                      status, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag,
                      tenant_id)
VALUES ('1904963524960378881', '1904960886332121090', '工作台', '/dashboard/workbench', 'svg:avatar-4',
        '/dashboard/workspace/index', 1, 1, 0, '1', '0', 1, 'GZT', 'AWC', 'admin', '2025-03-27 02:27:52', 'admin',
        '2025-03-27 04:01:33', '0', '0');
INSERT INTO sys_menu (menu_id, parent_id, menu_name, route_path, icon, component, is_show, keep_alive, is_ext, type,
                      status, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag,
                      tenant_id)
VALUES ('1904964341289377794', '0', '系统管理', '/system', 'bx:bx-home', 'BasicLayout', 1, 1, 0, '0', '0', 1, 'XTGL',
        'TXTG', 'admin', '2025-03-27 02:31:06', 'admin', '2025-03-27 04:01:19', '0', '0');
INSERT INTO sys_menu (menu_id, parent_id, menu_name, route_path, icon, component, is_show, keep_alive, is_ext, type,
                      status, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag,
                      tenant_id)
VALUES ('1904964771977289730', '1904964341289377794', '菜单管理', '/system/menu', 'svg:avatar-3', '/system/menu/index',
        1, 1, 0, '1', '0', 1, 'CDGL', 'AUTG', 'admin', '2025-03-27 02:32:49', 'admin', '2025-03-27 04:01:19', '0', '0');
INSERT INTO sys_menu (menu_id, parent_id, menu_name, route_path, icon, component, is_show, keep_alive, is_ext, type,
                      status, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag,
                      tenant_id)
VALUES ('1905286403015036930', '1904964341289377794', '职位管理', '/system/SysPost', NULL, '/system/SysPost/index', 1,
        1, 0, '1', '0', 1, 'ZWGL', 'BWTG', 'admin', '2025-03-27 23:50:52', 'admin', '2025-03-27 23:51:25', '0', '0');
INSERT INTO sys_menu (menu_id, parent_id, menu_name, route_path, icon, component, is_show, keep_alive, is_ext, type,
                      status, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag,
                      tenant_id)
VALUES ('1905286752295702530', '1904964341289377794', '角色管理', '/system/role', NULL, '/system/role/index', 1, 1, 0,
        '1', '0', 2, 'JSGL', 'QQTG', 'admin', '2025-03-27 23:52:15', 'admin', '2025-03-27 23:54:11', '0', '0');
INSERT INTO sys_menu (menu_id, parent_id, menu_name, route_path, icon, component, is_show, keep_alive, is_ext, type,
                      status, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag,
                      tenant_id)
VALUES ('1905286911305961473', '1904964341289377794', '部门管理', '/system/dept', NULL, '/system/dept/index', 1, 1, 0,
        '1', '0', 2, 'BMGL', 'UUTG', 'admin', '2025-03-27 23:52:53', 'admin', '2025-03-27 23:52:53', '0', '0');
INSERT INTO sys_menu (menu_id, parent_id, menu_name, route_path, icon, component, is_show, keep_alive, is_ext, type,
                      status, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag,
                      tenant_id)
VALUES ('1905289514605596674', '1904964341289377794', '账号管理', '/system/user', NULL, '/system/user/index', 1, 1, 0,
        '1', '0', 1, 'ZHGL', 'MKTG', 'admin', '2025-03-28 00:03:14', 'admin', '2025-03-28 00:03:14', '0', '0');
INSERT INTO sys_menu (menu_id, parent_id, menu_name, route_path, icon, component, is_show, keep_alive, is_ext, type,
                      status, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag,
                      tenant_id)
VALUES ('1906496908169781250', '0', '运维平台', '/devops', NULL, 'BasicLayout', 1, 1, 0, '0', '0', 1, 'YWPT', 'FXGC',
        'admin', '2025-03-31 08:00:59', 'admin', '2025-03-31 08:00:59', '0', '0');
INSERT INTO sys_menu (menu_id, parent_id, menu_name, route_path, icon, component, is_show, keep_alive, is_ext, type,
                      status, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag,
                      tenant_id)
VALUES ('1906497126877569026', '1906496908169781250', '字典管理', '/cms/dict', NULL, '/devOps/dict/index', 1, 1, 0, '1',
        '0', 1, 'ZDGL', 'PMTG', 'admin', '2025-03-31 08:01:51', 'admin', '2025-03-31 08:01:51', '0', '0');
INSERT INTO sys_menu (menu_id, parent_id, menu_name, route_path, icon, component, is_show, keep_alive, is_ext, type,
                      status, order_no, pinyin_code, wubi_code, create_by, create_at, update_by, update_at, delete_flag,
                      tenant_id)
VALUES ('1906497949288308738', '1906496908169781250', '配置参数管理', '/devOps/config', NULL, '/devOps/config/index', 1,
        1, 0, '1', '0', 1, 'PZCSGL', 'SLCOTG', 'admin', '2025-03-31 08:05:07', 'admin', '2025-03-31 08:05:07', '0',
        '0');
COMMIT;
